﻿CREATE TABLE [flcrTM].[DEVICE_CATEGORY] (
    [TM_DEVICE_CATEGORY_ID] INT           IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]              INT           NOT NULL,
    [DEVICE_CATEGORY_ID]    INT           NOT NULL,
    [AUDIT_USER]            VARCHAR (50)  NOT NULL,
    [AUDIT_DTTM]            DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]         INT           NOT NULL,
    [AUDIT_MOD_USER]        VARCHAR (50)  NOT NULL,
    [AUDIT_MOD_DTTM]        DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]     INT           NOT NULL,
    [BUILTIN]               BIT           NOT NULL,
    [ACTIVE_FLG]            BIT           NOT NULL,
    [SORT_ORDER]            INT           NOT NULL,
    [DEVICE_CAT_NAME]       VARCHAR (100) NOT NULL,
    [DEVICE_CAT_DESC]       VARCHAR (250) NOT NULL
);

